Lighting night time scenes is tricky, but fortunately, with the help of decades of cinematography tricks to work with, we can break down how movies are lit, and apply those tricks to our own 3D environments. The fundamentals are the same, so it doesn't really matter which renderer you're using. I want to clarify that there are HUNDREDS of ways to light things, and this is only one way to do that. Feel free to share your own approach in the comments!
You'll soon realize that moonlight is a fickle beast, but it can be tamed, and faking it, tricking the audience into believing something through good lighting is key.